From 4484fd804b1e728dd6386bf6a99125422643dbcb Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc kop@karlpinc.com" <kop@karlpinc.com>
Date: Wed, 5 Aug 2026 14:46:46 +0000
Subject: [PATCH] Add example query to COLOBUS doc

---
 doc/src/tables/colobus.m4 | 52 ++++++++++++++++++++++++++++++++++++---
 1 file changed, 48 insertions(+), 4 deletions(-)

diff --git a/doc/src/tables/colobus.m4 b/doc/src/tables/colobus.m4
index 197b0f1..31e151d 100644
--- a/doc/src/tables/colobus.m4
+++ b/doc/src/tables/colobus.m4
@@ -31,10 +31,6 @@ COLOBUS (COLOBUS encounters)
 
 |COLOBUS_summary|
 
-.. sidebar::
-
-   |OBS helpful|
-
 The related |EVENTS| row must be a colobus monkey encounter event; it
 must have an |EVENTS|.\ |EVENTS.Behavior| value of ``sdb_colobus``.
 This related |EVENTS| row supplies the start and stop times for the
@@ -78,6 +74,54 @@ For further information, including additional data integrity rules,
 see the documentation of the :ref:`EVENTS <EVENTS_colobus_code>`
 table.
 
+The |OBS| view is useful when querying COLOBUS.
+
+.. code-block:: sql
+   :caption:
+      Using OBS to provide a more complete picture of colobus encounters
+
+   SELECT obs.wid, obs.type
+        , obs.eid
+        , obs.date
+        , obs.animid AS focal
+        , obs.commid
+        , obs.start
+        , obs.stop
+        , colobus.startmap
+        , colobus.hunt
+        , colobus.hunters
+        , colobus.huntcert
+        , colobus.malehunt
+        , colobus.femalehunt
+        , colobus.focalhunt
+        , colobus.focalhuntcert
+        , colobus.kill
+        , colobus.killers
+        , colobus.numkills
+        , colobus.malenumkills
+        , colobus.femalenumkills
+        , colobus.focalmalenumkills
+        , colobus.focalfemalenumkills
+        , colobus.victimsages
+        , colobus.infantskilled
+        , colobus.juvenileskilled
+        , colobus.adultskilled
+        , colobus.noagekilled
+        , colobus.groupsize
+        , colobus.details
+        , colobus.vegetation
+        , colobus.failuredetails
+        , colobus.description
+        , obs.notes
+        , obs.event_notes
+     FROM obs
+       JOIN colobus
+            ON (colobus.eid = obs.eid)
+     WHERE obs.behavior = 'sdb_colobus'
+     ORDER BY obs.animid, obs.date, obs.start, obs.stop
+            , obs.eid;
+
+
 .. contents::
    :depth: 2
 
-- 
2.34.1